<?php

    class ExpensesController extends Controller {

        /**
         * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
         * using two-column layout. See 'protected/views/layouts/column2.php'.
         */
        public $layout = '//layouts/column2';

        /**
         * @return array action filters
         */
        public function filters() {
            return array(
                'accessControl', // perform access control for CRUD operations
            );
        }

        /**
         * Specifies the access control rules.
         * This method is used by the 'accessControl' filter.
         * @return array access control rules
         */
        public function accessRules() {
            return array(
                array('allow', // allow all users to perform 'index' and 'view' actions
                    'actions' => array('index', 'view'),
                    'users' => array('*'),
                ),
                array('allow', // allow authenticated user to perform 'create' and 'update' actions
                    'actions' => array('create', 'update'),
                    'users' => array('@'),
                ),
                array('allow', // allow admin user to perform 'admin' and 'delete' actions
                    'actions' => array('admin', 'delete'),
                    'users' => array('admin'),
                ),
                array('deny', // deny all users
                    'users' => array('*'),
                ),
            );
        }

        /**
         * Displays a particular model.
         * @param integer $id the ID of the model to be displayed
         */
        public function actionView($id) {
            $this->render('view', array(
                'model' => $this->loadModel($id),
            ));
        }

        /**
         * Creates a new model.
         * If creation is successful, the browser will be redirected to the 'view' page.
         */
        public function actionCreate() {
            $model = new Expenses;

            // Uncomment the following line if AJAX validation is needed
            $this->performAjaxValidation($model);

            if (isset($_POST['Expenses'])) {
                $model->attributes = $_POST['Expenses'];
                if ($model->save())
                    $this->redirect(array('index'));
            }

            $this->render('create', array(
                'model' => $model,
            ));
        }

        /**
         * Updates a particular model.
         * If update is successful, the browser will be redirected to the 'view' page.
         * @param integer $id the ID of the model to be updated
         */
        public function actionUpdate($id) {
            $model = $this->loadModel($id);

            // Uncomment the following line if AJAX validation is needed
            // $this->performAjaxValidation($model);

            if (isset($_POST['Expenses'])) {
                $model->attributes = $_POST['Expenses'];
                if ($model->save())
                    $this->redirect(array('view', 'id' => $model->id));
            }

            $this->render('update', array(
                'model' => $model,
            ));
        }

        /**
         * Deletes a particular model.
         * If deletion is successful, the browser will be redirected to the 'admin' page.
         * @param integer $id the ID of the model to be deleted
         */
        public function actionDelete($id) {
            if (Yii::app()->request->isPostRequest) {
                // we only allow deletion via POST request
                $this->loadModel($id)->delete();

                // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
                if (!isset($_GET['ajax']))
                    $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
            }
            else
                throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.');
        }

        /**
         * Lists all models.
         */
        public function actionIndex() {
            $dataProvider = new CActiveDataProvider(Expenses::model()->with('user', 'user.profile'), array(
                'sort' => array(
                    'attributes' => array(
                        'user.user_code' => array(
                            'asc' => 'user.user_code',
                            'desc' => 'user.user_code DESC',
                        ),
                        'user.profile.firstname' => array(
                            'asc' => 'profile.firstname',
                            'desc' => 'profile.firstname DESC',
                        ),
                        'user.profile.lastname' => array(
                            'asc' => 'profile.lastname',
                            'desc' => 'profile.lastname DESC',
                        ),
                        'item' => array(
                            'asc' => 'item',
                            'desc' => 'item DESC',
                        ),
                        'amount' => array(
                            'asc' => 'amount',
                            'desc' => 'amount DESC',
                        ),
                        'on_date' => array(
                            'asc' => 'on_date',
                            'desc' => 'on_date DESC',
                        ),
                        'createtime' => array(
                            'asc' => 't.createtime',
                            'desc' => 't.createtime DESC',
                        ),
                        'modifytime' => array(
                            'asc' => 'modifytime',
                            'desc' => 'modifytime DESC',
                        ),
                        'updateby_user_id' => array(
                            'asc' => 'updateby_user_id',
                            'desc' => 'updateby_user_id DESC',
                        ),
                    ),
                ),
            ));
            $this->render('index', array(
                'dataProvider' => $dataProvider,
            ));
        }

        /**
         * Manages all models.
         */
        public function actionAdmin() {
            $model = new Expenses('search');
            $model->unsetAttributes();  // clear any default values
            if (isset($_GET['Expenses']))
                $model->attributes = $_GET['Expenses'];

            $this->render('admin', array(
                'model' => $model,
            ));
        }

        /**
         * Returns the data model based on the primary key given in the GET variable.
         * If the data model is not found, an HTTP exception will be raised.
         * @param integer the ID of the model to be loaded
         */
        public function loadModel($id) {
            $model = Expenses::model()->findByPk($id);
            if ($model === null)
                throw new CHttpException(404, 'The requested page does not exist.');
            return $model;
        }

        /**
         * Performs the AJAX validation.
         * @param CModel the model to be validated
         */
        protected function performAjaxValidation($model) {
            if (isset($_POST['ajax']) && $_POST['ajax'] === 'expenses-form') {
                echo CActiveForm::validate($model);
                Yii::app()->end();
            }
        }

    }

